{
  "statement":"with ws as\n  (select d_year AS ws_sold_year, ws_item_sk,\n    ws_bill_customer_sk ws_customer_sk,\n    sum(ws_quantity) ws_qty,\n    sum(ws_wholesale_cost) ws_wc,\n    sum(ws_sales_price) ws_sp\n   from web_sales\n   left join web_returns on wr_order_number\u003dws_order_number and ws_item_sk\u003dwr_item_sk\n   join date_dim on ws_sold_date_sk \u003d d_date_sk\n   where wr_order_number is null\n   group by d_year, ws_item_sk, ws_bill_customer_sk\n   ),\ncs as\n  (select d_year AS cs_sold_year, cs_item_sk,\n    cs_bill_customer_sk cs_customer_sk,\n    sum(cs_quantity) cs_qty,\n    sum(cs_wholesale_cost) cs_wc,\n    sum(cs_sales_price) cs_sp\n   from catalog_sales\n   left join catalog_returns on cr_order_number\u003dcs_order_number and cs_item_sk\u003dcr_item_sk\n   join date_dim on cs_sold_date_sk \u003d d_date_sk\n   where cr_order_number is null\n   group by d_year, cs_item_sk, cs_bill_customer_sk\n   ),\nss as\n  (select d_year AS ss_sold_year, ss_item_sk,\n    ss_customer_sk,\n    sum(ss_quantity) ss_qty,\n    sum(ss_wholesale_cost) ss_wc,\n    sum(ss_sales_price) ss_sp\n   from store_sales\n   left join store_returns on sr_ticket_number\u003dss_ticket_number and ss_item_sk\u003dsr_item_sk\n   join date_dim on ss_sold_date_sk \u003d d_date_sk\n   where sr_ticket_number is null\n   group by d_year, ss_item_sk, ss_customer_sk\n   )\n select\nss_sold_year, ss_item_sk, ss_customer_sk,\nround(ss_qty/(coalesce(ws_qty,0)+coalesce(cs_qty,0)),2) ratio,\nss_qty store_qty, ss_wc store_wholesale_cost, ss_sp store_sales_price,\ncoalesce(ws_qty,0)+coalesce(cs_qty,0) other_chan_qty,\ncoalesce(ws_wc,0)+coalesce(cs_wc,0) other_chan_wholesale_cost,\ncoalesce(ws_sp,0)+coalesce(cs_sp,0) other_chan_sales_price\nfrom ss\nleft join ws on (ws_sold_year\u003dss_sold_year and ws_item_sk\u003dss_item_sk and ws_customer_sk\u003dss_customer_sk)\nleft join cs on (cs_sold_year\u003dss_sold_year and cs_item_sk\u003dss_item_sk and cs_customer_sk\u003dss_customer_sk)\nwhere (coalesce(ws_qty,0)\u003e0 or coalesce(cs_qty, 0)\u003e0) and ss_sold_year\u003d2000\norder by\n  ss_sold_year, ss_item_sk, ss_customer_sk,\n  ss_qty desc, ss_wc desc, ss_sp desc,\n  other_chan_qty,\n  other_chan_wholesale_cost,\n  other_chan_sales_price,\n  ratio\nlimit 100;\n",
  "table_meta":{
    "tpcds.web_sales":"CREATE TABLE `web_sales` (\n  `ws_item_sk` int(11) NOT NULL COMMENT \"\",\n  `ws_order_number` int(11) NOT NULL COMMENT \"\",\n  `ws_sold_date_sk` int(11) NULL COMMENT \"\",\n  `ws_sold_time_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_date_sk` int(11) NULL COMMENT \"\",\n  `ws_bill_customer_sk` int(11) NULL COMMENT \"\",\n  `ws_bill_cdemo_sk` int(11) NULL COMMENT \"\",\n  `ws_bill_hdemo_sk` int(11) NULL COMMENT \"\",\n  `ws_bill_addr_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_customer_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_cdemo_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_hdemo_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_addr_sk` int(11) NULL COMMENT \"\",\n  `ws_web_page_sk` int(11) NULL COMMENT \"\",\n  `ws_web_site_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_mode_sk` int(11) NULL COMMENT \"\",\n  `ws_warehouse_sk` int(11) NULL COMMENT \"\",\n  `ws_promo_sk` int(11) NULL COMMENT \"\",\n  `ws_quantity` int(11) NULL COMMENT \"\",\n  `ws_wholesale_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_list_price` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_sales_price` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_ext_discount_amt` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_ext_sales_price` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_ext_wholesale_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_ext_list_price` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_ext_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_coupon_amt` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_ext_ship_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_net_paid` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_net_paid_inc_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_net_paid_inc_ship` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_net_paid_inc_ship_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `ws_net_profit` decimal64(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`ws_item_sk`, `ws_order_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`ws_item_sk`, `ws_order_number`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.web_returns":"CREATE TABLE `web_returns` (\n  `wr_item_sk` int(11) NOT NULL COMMENT \"\",\n  `wr_order_number` int(11) NOT NULL COMMENT \"\",\n  `wr_returned_date_sk` int(11) NULL COMMENT \"\",\n  `wr_returned_time_sk` int(11) NULL COMMENT \"\",\n  `wr_refunded_customer_sk` int(11) NULL COMMENT \"\",\n  `wr_refunded_cdemo_sk` int(11) NULL COMMENT \"\",\n  `wr_refunded_hdemo_sk` int(11) NULL COMMENT \"\",\n  `wr_refunded_addr_sk` int(11) NULL COMMENT \"\",\n  `wr_returning_customer_sk` int(11) NULL COMMENT \"\",\n  `wr_returning_cdemo_sk` int(11) NULL COMMENT \"\",\n  `wr_returning_hdemo_sk` int(11) NULL COMMENT \"\",\n  `wr_returning_addr_sk` int(11) NULL COMMENT \"\",\n  `wr_web_page_sk` int(11) NULL COMMENT \"\",\n  `wr_reason_sk` int(11) NULL COMMENT \"\",\n  `wr_return_quantity` int(11) NULL COMMENT \"\",\n  `wr_return_amt` decimal64(7, 2) NULL COMMENT \"\",\n  `wr_return_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `wr_return_amt_inc_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `wr_fee` decimal64(7, 2) NULL COMMENT \"\",\n  `wr_return_ship_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `wr_refunded_cash` decimal64(7, 2) NULL COMMENT \"\",\n  `wr_reversed_charge` decimal64(7, 2) NULL COMMENT \"\",\n  `wr_account_credit` decimal64(7, 2) NULL COMMENT \"\",\n  `wr_net_loss` decimal64(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`wr_item_sk`, `wr_order_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`wr_item_sk`, `wr_order_number`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.catalog_sales":"CREATE TABLE `catalog_sales` (\n  `cs_item_sk` int(11) NOT NULL COMMENT \"\",\n  `cs_order_number` int(11) NOT NULL COMMENT \"\",\n  `cs_sold_date_sk` int(11) NULL COMMENT \"\",\n  `cs_sold_time_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_date_sk` int(11) NULL COMMENT \"\",\n  `cs_bill_customer_sk` int(11) NULL COMMENT \"\",\n  `cs_bill_cdemo_sk` int(11) NULL COMMENT \"\",\n  `cs_bill_hdemo_sk` int(11) NULL COMMENT \"\",\n  `cs_bill_addr_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_customer_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_cdemo_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_hdemo_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_addr_sk` int(11) NULL COMMENT \"\",\n  `cs_call_center_sk` int(11) NULL COMMENT \"\",\n  `cs_catalog_page_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_mode_sk` int(11) NULL COMMENT \"\",\n  `cs_warehouse_sk` int(11) NULL COMMENT \"\",\n  `cs_promo_sk` int(11) NULL COMMENT \"\",\n  `cs_quantity` int(11) NULL COMMENT \"\",\n  `cs_wholesale_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_list_price` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_sales_price` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_ext_discount_amt` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_ext_sales_price` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_ext_wholesale_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_ext_list_price` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_ext_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_coupon_amt` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_ext_ship_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_net_paid` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_net_paid_inc_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_net_paid_inc_ship` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_net_paid_inc_ship_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `cs_net_profit` decimal64(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`cs_item_sk`, `cs_order_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`cs_item_sk`, `cs_order_number`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.catalog_returns":"CREATE TABLE `catalog_returns` (\n  `cr_item_sk` int(11) NOT NULL COMMENT \"\",\n  `cr_order_number` int(11) NOT NULL COMMENT \"\",\n  `cr_returned_date_sk` int(11) NULL COMMENT \"\",\n  `cr_returned_time_sk` int(11) NULL COMMENT \"\",\n  `cr_refunded_customer_sk` int(11) NULL COMMENT \"\",\n  `cr_refunded_cdemo_sk` int(11) NULL COMMENT \"\",\n  `cr_refunded_hdemo_sk` int(11) NULL COMMENT \"\",\n  `cr_refunded_addr_sk` int(11) NULL COMMENT \"\",\n  `cr_returning_customer_sk` int(11) NULL COMMENT \"\",\n  `cr_returning_cdemo_sk` int(11) NULL COMMENT \"\",\n  `cr_returning_hdemo_sk` int(11) NULL COMMENT \"\",\n  `cr_returning_addr_sk` int(11) NULL COMMENT \"\",\n  `cr_call_center_sk` int(11) NULL COMMENT \"\",\n  `cr_catalog_page_sk` int(11) NULL COMMENT \"\",\n  `cr_ship_mode_sk` int(11) NULL COMMENT \"\",\n  `cr_warehouse_sk` int(11) NULL COMMENT \"\",\n  `cr_reason_sk` int(11) NULL COMMENT \"\",\n  `cr_return_quantity` int(11) NULL COMMENT \"\",\n  `cr_return_amount` decimal64(7, 2) NULL COMMENT \"\",\n  `cr_return_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `cr_return_amt_inc_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `cr_fee` decimal64(7, 2) NULL COMMENT \"\",\n  `cr_return_ship_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `cr_refunded_cash` decimal64(7, 2) NULL COMMENT \"\",\n  `cr_reversed_charge` decimal64(7, 2) NULL COMMENT \"\",\n  `cr_store_credit` decimal64(7, 2) NULL COMMENT \"\",\n  `cr_net_loss` decimal64(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`cr_item_sk`, `cr_order_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`cr_item_sk`, `cr_order_number`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.store_sales":"CREATE TABLE `store_sales` (\n  `ss_item_sk` int(11) NOT NULL COMMENT \"\",\n  `ss_ticket_number` int(11) NOT NULL COMMENT \"\",\n  `ss_sold_date_sk` int(11) NULL COMMENT \"\",\n  `ss_sold_time_sk` int(11) NULL COMMENT \"\",\n  `ss_customer_sk` int(11) NULL COMMENT \"\",\n  `ss_cdemo_sk` int(11) NULL COMMENT \"\",\n  `ss_hdemo_sk` int(11) NULL COMMENT \"\",\n  `ss_addr_sk` int(11) NULL COMMENT \"\",\n  `ss_store_sk` int(11) NULL COMMENT \"\",\n  `ss_promo_sk` int(11) NULL COMMENT \"\",\n  `ss_quantity` int(11) NULL COMMENT \"\",\n  `ss_wholesale_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_list_price` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_sales_price` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_ext_discount_amt` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_ext_sales_price` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_ext_wholesale_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_ext_list_price` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_ext_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_coupon_amt` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_net_paid` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_net_paid_inc_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `ss_net_profit` decimal64(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`ss_item_sk`, `ss_ticket_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`ss_item_sk`, `ss_ticket_number`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.store_returns":"CREATE TABLE `store_returns` (\n  `sr_item_sk` int(11) NOT NULL COMMENT \"\",\n  `sr_ticket_number` int(11) NOT NULL COMMENT \"\",\n  `sr_returned_date_sk` int(11) NULL COMMENT \"\",\n  `sr_return_time_sk` int(11) NULL COMMENT \"\",\n  `sr_customer_sk` int(11) NULL COMMENT \"\",\n  `sr_cdemo_sk` int(11) NULL COMMENT \"\",\n  `sr_hdemo_sk` int(11) NULL COMMENT \"\",\n  `sr_addr_sk` int(11) NULL COMMENT \"\",\n  `sr_store_sk` int(11) NULL COMMENT \"\",\n  `sr_reason_sk` int(11) NULL COMMENT \"\",\n  `sr_return_quantity` int(11) NULL COMMENT \"\",\n  `sr_return_amt` decimal64(7, 2) NULL COMMENT \"\",\n  `sr_return_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `sr_return_amt_inc_tax` decimal64(7, 2) NULL COMMENT \"\",\n  `sr_fee` decimal64(7, 2) NULL COMMENT \"\",\n  `sr_return_ship_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `sr_refunded_cash` decimal64(7, 2) NULL COMMENT \"\",\n  `sr_reversed_charge` decimal64(7, 2) NULL COMMENT \"\",\n  `sr_store_credit` decimal64(7, 2) NULL COMMENT \"\",\n  `sr_net_loss` decimal64(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`sr_item_sk`, `sr_ticket_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`sr_item_sk`, `sr_ticket_number`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.date_dim":"CREATE TABLE `date_dim` (\n  `d_date_sk` int(11) NOT NULL COMMENT \"\",\n  `d_date_id` char(16) NOT NULL COMMENT \"\",\n  `d_date` date NULL COMMENT \"\",\n  `d_month_seq` int(11) NULL COMMENT \"\",\n  `d_week_seq` int(11) NULL COMMENT \"\",\n  `d_quarter_seq` int(11) NULL COMMENT \"\",\n  `d_year` int(11) NULL COMMENT \"\",\n  `d_dow` int(11) NULL COMMENT \"\",\n  `d_moy` int(11) NULL COMMENT \"\",\n  `d_dom` int(11) NULL COMMENT \"\",\n  `d_qoy` int(11) NULL COMMENT \"\",\n  `d_fy_year` int(11) NULL COMMENT \"\",\n  `d_fy_quarter_seq` int(11) NULL COMMENT \"\",\n  `d_fy_week_seq` int(11) NULL COMMENT \"\",\n  `d_day_name` char(9) NULL COMMENT \"\",\n  `d_quarter_name` char(6) NULL COMMENT \"\",\n  `d_holiday` char(1) NULL COMMENT \"\",\n  `d_weekend` char(1) NULL COMMENT \"\",\n  `d_following_holiday` char(1) NULL COMMENT \"\",\n  `d_first_dom` int(11) NULL COMMENT \"\",\n  `d_last_dom` int(11) NULL COMMENT \"\",\n  `d_same_day_ly` int(11) NULL COMMENT \"\",\n  `d_same_day_lq` int(11) NULL COMMENT \"\",\n  `d_current_day` char(1) NULL COMMENT \"\",\n  `d_current_week` char(1) NULL COMMENT \"\",\n  `d_current_month` char(1) NULL COMMENT \"\",\n  `d_current_quarter` char(1) NULL COMMENT \"\",\n  `d_current_year` char(1) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`d_date_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`d_date_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);"
  },
  "table_row_count":{
    "tpcds.catalog_sales":{
      "catalog_sales":143997065
    },
    "tpcds.store_sales":{
      "store_sales":287997024
    },
    "tpcds.web_returns":{
      "web_returns":7197670
    },
    "tpcds.store_returns":{
      "store_returns":28795080
    },
    "tpcds.web_sales":{
      "web_sales":71913344
    },
    "tpcds.date_dim":{
      "date_dim":73049
    },
    "tpcds.catalog_returns":{
      "catalog_returns":14404374
    }
  },
  "session_variables":"{\"runtime_join_filter_push_down_limit\":2048000,\"codegen_level\":0,\"cbo_cte_reuse\":false,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":true,\"div_precision_increment\":4,\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"auto_increment_increment\":1,\"foreign_key_checks\":true,\"character_set_client\":\"utf8\",\"autocommit\":true,\"character_set_results\":\"utf8\",\"parallel_fragment_exec_instance_num\":24,\"max_scan_key_num\":-1,\"enable_global_runtime_filter\":true,\"forward_to_master\":false,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"cbo_enable_dp_join_reorder\":true,\"cbo_enable_low_cardinality_optimize\":true,\"tx_visible_wait_timeout\":10,\"cbo_max_reorder_node_use_exhaustive\":4,\"new_planner_optimize_timeout\":3000,\"force_schedule_local\":false,\"query_threads\":1,\"enable_query_dump\":false,\"cbo_enable_greedy_join_reorder\":true,\"prefer_join_method\":\"broadcast\",\"load_mem_limit\":0,\"sql_select_limit\":9223372036854775807,\"profiling\":false,\"sql_safe_updates\":0,\"enable_pipeline_engine\":false,\"query_cache_type\":0,\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"enable_vectorized_engine\":true,\"net_write_timeout\":60,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"normal\",\"enable_new_planner_push_down_join_to_agg\":false,\"broadcast_row_limit\":15000000,\"exec_mem_limit\":32212254720,\"cbo_max_reorder_node_use_dp\":10,\"disable_join_reorder\":false,\"enable_profile\":true,\"enable_groupby_use_output_alias\":false,\"net_buffer_length\":16384,\"transmission_compression_type\":\"LZ4\",\"enable_vectorized_insert\":true,\"interactive_timeout\":3600,\"enable_spilling\":false,\"batch_size\":1024,\"max_allowed_packet\":1048576,\"query_timeout\":300,\"enable_cbo\":true,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"Asia/Shanghai\",\"max_execution_time\":3000000,\"character_set_server\":\"utf8\",\"rewrite_count_distinct_to_bitmap_hll\":true,\"parallel_exchange_instance_num\":-1,\"sql_mode\":34,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"disable_streaming_preaggregations\":false}",
  "column_statistics":{
    "tpcds.catalog_sales":{
      "cs_order_number":"[33.0, 1.5999877E7, 0.0, 4.0, 1.4002849E7]",
      "cs_sold_date_sk":"[2450815.0, 2452654.0, 0.005075, 4.0, 1837.0]",
      "cs_item_sk":"[1.0, 54687.0, 0.0, 4.0, 53212.0]",
      "cs_quantity":"[1.0, 100.0, 0.004905, 4.0, 101.0]",
      "cs_wholesale_cost":"[1.0, 100.0, 0.00486, 8.0, 9902.0]",
      "cs_sales_price":"[0.0, 293.97, 0.00478, 8.0, 21086.0]",
      "cs_bill_customer_sk":"[8.0, 1999999.0, 0.005015, 4.0, 1723505.0]"
    },
    "tpcds.store_sales":{
      "ss_customer_sk":"[6.0, 1999992.0, 0.044985, 4.0, 1283554.0]",
      "ss_ticket_number":"[120.0, 2.399982E7, 0.0, 4.0, 1.9067741E7]",
      "ss_wholesale_cost":"[1.0, 100.0, 0.04522, 8.0, 9902.0]",
      "ss_item_sk":"[1.0, 33031.0, 0.0, 4.0, 32743.0]",
      "ss_sold_date_sk":"[2450816.0, 2452642.0, 0.045215, 4.0, 1824.0]",
      "ss_quantity":"[1.0, 100.0, 0.0454, 4.0, 101.0]",
      "ss_sales_price":"[0.0, 195.84, 0.04506, 8.0, 15377.0]"
    },
    "tpcds.web_returns":{
      "wr_order_number":"[33.0, 5999976.0, 0.0, 4.0, 3385141.0]",
      "wr_item_sk":"[1.0, 28303.0, 0.0, 4.0, 28123.0]"
    },
    "tpcds.store_returns":{
      "sr_ticket_number":"[462.0, 2.3999821E7, 0.0, 4.0, 1.3569503E7]",
      "sr_item_sk":"[1.0, 7094.0, 0.0, 4.0, 7094.0]"
    },
    "tpcds.web_sales":{
      "ws_order_number":"[39.0, 5999996.0, 0.0, 4.0, 5884808.0]",
      "ws_item_sk":"[1.0, 108621.0, 0.0, 4.0, 100594.0]",
      "ws_quantity":"[1.0, 100.0, 2.1E-4, 4.0, 101.0]",
      "ws_sold_date_sk":"[2450816.0, 2452642.0, 1.9E-4, 4.0, 1824.0]",
      "ws_bill_customer_sk":"[20.0, 1999983.0, 2.2E-4, 4.0, 1517228.0]",
      "ws_sales_price":"[0.0, 292.0, 2.35E-4, 8.0, 21157.0]",
      "ws_wholesale_cost":"[1.0, 100.0, 2.15E-4, 8.0, 9902.0]"
    },
    "tpcds.date_dim":{
      "d_date_sk":"[2415022.0, 2488070.0, 0.0, 4.0, 72542.0]",
      "d_year":"[1900.0, 2100.0, 0.0, 4.0, 202.0]"
    },
    "tpcds.catalog_returns":{
      "cr_order_number":"[4.0, 1.6E7, 0.0, 4.0, 7320161.0]",
      "cr_item_sk":"[1.0, 14145.0, 0.0, 4.0, 14141.0]"
    }
  },
  "be_number":5,
  "exception":[

  ]
}
